package com.liang.jiekou.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.liang.jiekou.entity.COPTC;
import com.liang.jiekou.entity.COPTD;
import com.liang.jiekou.entity.INVMB;
import com.liang.jiekou.entity.result.COPTCD;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface COPTCDMapper {
   //查询客户订单单头
    @DS("demo")
    COPTC selectCOPTC(String TC001, String TC002);


    //查询客户订单单身
    @DS("demo")
    List<COPTD> selectCOPTD(String TC001, String TC002);

 //查询客户订单单头
 @DS("demo")
 IPage<COPTC> selectCOPTCall(Page<COPTCD> page, String startcreate, String endcreate, String startupdate, String endupdate);


 //查询客户订单单身
 @DS("demo")
 IPage<COPTD> selectCOPTDall(Page<COPTCD> page,String startcreate, String endcreate, String startupdate, String endupdate);


 @DS("demo")
 @Select("select  * from COPTC")
 List<COPTC> selectCoptcList();

 @DS("demo")
 @Select("select * from COPTD where TD001 = #{tc001} and TD002 = #{tc002}")
 List<COPTD> selectCoptdList(String tc001, String tc002);

 @DS("demo")

 List<COPTC> selectPageCoptcList(Integer page, Integer pageSize, String startcreate, String endcreate, String startupdate, String endupdate);

 @DS("demo")
 List<COPTC> selectCoptcListByCreateDateWithModiDate(String startcreate, String endcreate, String startupdate, String endupdate);
}
